Performance Monitoring of Climate Change Strategy

Progress update

NYC’s Data and insight team have been progressing the development of a Power BI data analytics and visualisation tool for tracking progress on the Climate Change Strategy delivery pathways. Interfacing directly with council systems, the tool is being designed to pull data regularly and automatically on scope 1,2, and 3 emissions from activities like fleet use, staff travel and energy consumption. A prototype has now been part developed for the NYC Fleet system which enables trend analysis of mileage by financial year, mileage analysis by make and model of vehicle and a detailed view of journeys by duration and mileage. This should be completed by the end of June 2026. Under development is presentation of the mileage by directorate and service, showing mileage by fuel type and direct conversion into CO2 emissions.

Through this quarter, development will also be progressed on Grey Fleet and Property dashboards. The Grey Fleet will follow a similar format to Fleet and allow comparable reporting capability. The Property dashboard will show energy usage by NYC properties.

A system is also being created to hold corporate and directorate action plans so that this data can be pulled into a dashboard. This dashboard will support easier monitoring of RAG status and progress against delivery pathway action plans KPI’s which address key areas outlined in the five themes of the Climate Change Strategy and Delivery Pathway: governance, mitigation, adaptation, supporting nature and North Yorkshire Council (NYC) net zero ambitions. Streamlining and automating some data collection processes will reduce outdated manual processes and deliver beneficial efficiencies in Officer time for the Climate Change team.

The project remains on track to deliver the benefits of significantly enhancing monitoring, achieving quarterly reporting capability and improving the accessibility of data. Through visual and customisable reports, it will enable a clearer presentation of trends and trajectories whilst also allowing aggregation of directorate-level data to a corporate view. The dashboards will also support executive reporting and FOI responding.

Below are screenshots to show example dashboard functionality taken from the Fleet prototype which is in development:

Above: Detailed view of journeys by duration and mileage

Above: Trend analysis of mileage by financial year

Above: Mileage analysis by make and model